﻿-- =============================================
-- Script Template
-- =============================================

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

/****Create Default Records ****/
PRINT 'INSERTING DEFAULT DATA .... [Sys_ActivityTypeMaster]'
GO

	SET IDENTITY_INSERT [Sys_ActivityTypeMaster] ON
	INSERT [Sys_ActivityTypeMaster] ([ActivityTypeKey], [ActivityTypeCode], [ActivityTypeName], [ActivityTypeDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, N'VIEW', N'View Static Screens', N'View Static Screens', GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
	INSERT [Sys_ActivityTypeMaster] ([ActivityTypeKey], [ActivityTypeCode], [ActivityTypeName], [ActivityTypeDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, N'READ', N'Read Data any data from DB', N'Read Data any data from DB', GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
	INSERT [Sys_ActivityTypeMaster] ([ActivityTypeKey], [ActivityTypeCode], [ActivityTypeName], [ActivityTypeDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, N'SEE', N'See only self created data from DB', N'See only self created data from DB', GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
	INSERT [Sys_ActivityTypeMaster] ([ActivityTypeKey], [ActivityTypeCode], [ActivityTypeName], [ActivityTypeDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, N'CREATE', N'Create New Data in DB', N'Create New Data in DB', GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
	INSERT [Sys_ActivityTypeMaster] ([ActivityTypeKey], [ActivityTypeCode], [ActivityTypeName], [ActivityTypeDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, N'EDIT', N'Edit only self created data in DB', N'Edit only self created data in DB', GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
	INSERT [Sys_ActivityTypeMaster] ([ActivityTypeKey], [ActivityTypeCode], [ActivityTypeName], [ActivityTypeDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (6, N'UPDATE', N'Update any data in DB', N'Update any data in DB', GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
	INSERT [Sys_ActivityTypeMaster] ([ActivityTypeKey], [ActivityTypeCode], [ActivityTypeName], [ActivityTypeDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (7, N'REMOVE', N'ReMove self created data in DB', N'ReMove self created data in DB', GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
	INSERT [Sys_ActivityTypeMaster] ([ActivityTypeKey], [ActivityTypeCode], [ActivityTypeName], [ActivityTypeDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (8, N'DELETE', N'Delete any Data from DB', N'Delete any Data from DB', GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))

	SET IDENTITY_INSERT [Sys_ActivityTypeMaster] OFF